﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace FortuneHeavenCommon.DataMap
{
    public partial class IndividualDatum
    {
        public const string TABLE_NAME = "IndividualDatum";
        public const string INSERT_SQL = "insert into IndividualDatum([UserID],[Compellation],[QQ],[EMail],[SeatPhone],[MobilePhone],[DwellingPlace],[PostalCode],[CollectDate],[UserNote]) values (@UserID,@Compellation,@QQ,@EMail,@SeatPhone,@MobilePhone,@DwellingPlace,@PostalCode,@CollectDate,@UserNote)";
        public const string UPDATE_SQL = "UPDATE IndividualDatum SET [UserID]=@UserID,[Compellation]=@Compellation,[QQ]=@QQ,[EMail]=@EMail,[SeatPhone]=@SeatPhone,[MobilePhone]=@MobilePhone,[DwellingPlace]=@DwellingPlace,[PostalCode]=@PostalCode,[CollectDate]=@CollectDate,[UserNote]=@UserNote where ID = @ID";

        /// <summary>
        ///
        /// </summary>
        public int UserID
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string Compellation
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string QQ
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string EMail
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string SeatPhone
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string MobilePhone
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string DwellingPlace
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string PostalCode
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public DateTime CollectDate
        {
            get;
            set;
        }
        /// <summary>
        ///
        /// </summary>
        public string UserNote
        {
            get;
            set;
        }
    }

}
